=Chris Palmer
=Chris Palmer
Reactions
-
Re: =netday
@jivo they both have to have a property of Date for your formula to work. The issue is your primary column has a date. You need to create a duplicate column for example: Create a column named "T…2 · -
Re: SmartSheet Admin
Hello, This covers a general description. You may want to adjust for what your requirements are like formula knowledge. Job Title: Smartsheet Administrator Job Summary: As a Smartsheet Administrator,…2 · -
Re: Is there a way to convert a large number of contact cells at once?
Without seeing the data you're working with you can experiment with something like this: =SUBSTITUTE([Name Column]@row, " ", ".") + [Email Domain]@row This will take the name, sub…1 · -
Re: IF/AND formula
Hi Cheryl, Looks like you need some commas and one more parenthesis to initiate the IF AND Give this a shot and see if it works for you: =IF(AND([Half Day]@row = 1, [Leave Type]@row = "TOIL"…1 · -
Re: Blank Date in Duration
Hello @Michele R. Is this what you're going for? =IF(ISBLANK([Date Report Delivered to Ops]@row), "No Report", ROUNDUP([Date Report Delivered to Ops]@row - [Date Report Requested]@row)) You…1 ·
